| Named Ranges and Lookup |
Working with Named Ranges |
|
Vlookup and Hlookup Functions |
| Data Management |
Importing and Exporting Files |
|
Custom and Conditional Formats |
|
Validating Data |
|
XML and Web Queries |
| Group Editing |
Sharing and Protecting Files |
|
Using Comments |
|
Tracking Changes |
| Auditing, Scenarios and Reporting |
Auditing Tools |
|
Using the Scenario Manager |
|
Using Custom Views |
| Database and Analysis Tools |
Working with Databases |
|
Filtering Data |
|
Sorting and Subtotalling |
|
Goal Seeker and Solver |
| PivotTables |
Working with PivotTables |
|
Using PivotCharts |
|
PivotTables on the Web |
